package com.example.mapp.buildSql;

import org.apache.ibatis.jdbc.SQL;

import com.example.ext.entity.maintenance.ExtDebrisHalfMon;

/**
 * Created by douyx on 2017/11/2.
 */
public class DebrisMappSql {

	/**
     * 获取杂物电梯半月保数据
     * @param
     * @return
     */
    public String findDebrisHalfMon(final ExtDebrisHalfMon halfMon){
        String select = " DISTINCT sa.author_name,sa.parent_id,sa.author_url,sa.author_icon,sra.author_id";

        String table = " debris_half_mon d " +
                        "inner join elevator e on d.elevator_id = e.elevator_num ";

        String where = "";
        return new SQL(){{
            SELECT(select);
            FROM(table);
            WHERE(where);
            }
        }.toString();
    }
}
